from sqlalchemy import Integer, DECIMAL, Column, DateTime, String, BigInteger
from config.database import Base


class SalePackaging(Base):
    """
    包装费用管理表
    """

    __tablename__ = 'sale_packaging'

    packaging_id = Column(Integer, primary_key=True, autoincrement=True, nullable=False, comment='包装方式记录id')
    as_id = Column(BigInteger, nullable=False, comment='账套id')
    materials_cost = Column(DECIMAL, nullable=False, comment='包材费')
    chilling_fee = Column(String(255), nullable=False, comment='人工及打冷费')
    product_id = Column(Integer, nullable=False, comment='商品Id')
    product_name = Column(String(255), nullable=True, comment='商品名称')
    product_weight = Column(DECIMAL, nullable=False, comment='商品重量（斤）')
    year = Column(Integer, nullable=False, comment='数据年份')
    create_by = Column(String(255), nullable=True, comment='创建人')
    create_time = Column(DateTime, nullable=True, comment='创建时间')
    update_by = Column(String(255), nullable=True, comment='更新人')
    update_time = Column(DateTime, nullable=True, comment='更新时间')
    del_status = Column(Integer, nullable=True, comment='删除状态')



